<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://jsptags.com/tags/navigation/pager" prefix="pg"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn"%>
<%@taglib prefix="shiro" uri="http://shiro.apache.org/tags" %>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title></title>

    <link rel="stylesheet" type="text/css" href="<%=path%>/CSS/backLayout.css"> 
    <link rel="stylesheet" type="text/css" href="<%=path%>/CSS/bombBox.css">
    <script type="text/javascript" src="<%=path%>/My97DatePicker/WdatePicker.js"></script> 
    

    <%@ include file="/WEB-INF/JSP/backHome/modalWindows/personsListPage.jsp" %> 
        
    <style type="text/css">
        .seachform li label {
            line-height: 45px;
            color: #444444
        }

        .scinput {
            line-height: 10px;
            margin-top: 5px
        }

        .scinput1 {
            margin-top: 5px;
            height: 30px;
        }

        .scbtn {
            background: #57a0ff;
            border-radius: 20px;
            width: 110px;
            margin-top: 4px;
            height: 35px
        }

        .scbtn2 {
            height: 20px;
            background: #57a0ff;
            border-radius: 20px;
            width: 50px;
            color: #fff;
            display: none;
        }

        thead {
            background: #f2f2f2
        }

        tbody tr:nth-child(even) {
            background: #f7f8fd
        }

        tbody tr {
            height: 38px
        }

        .check {
            padding-left: 0px
        }

        a {
            cursor: pointer;
        }

        #table1 tr th {
            height: 20px;
            border-bottom: 1px solid #bbb;
            border-top: 1px solid #bbb;
            border-left: 1px solid #bbb;
            border-right: 1px solid #bbb
        }

        .template tr td {
            border: solid 1px #ccc;
            font-size: 12px;
        }

        .template tr th {
            font-size: 14px;

        }

        .scinput {
            line-height: 10px;
            margin-top: 5px
        }

        .scinput1 {
            margin-top: 5px;
            height: 30px;
        }

        thead {
            background: #f2f2f2
        }

        .template th {
            height: 45px;
            background: none;
        }

        .template tr {
            height: 45px;
        }

        .template tr th {
            height: 20px;
            border-left: 1px solid #dddee6;
            border-right: 1px solid #dddee6;
            color: #444444;
            text-align: center;
        }

        .tou {
            background: #e4eafe
        }

        .kh {
            border-bottom: 1px solid #dddee6;
        }

        .shuju td {
            border: 1px solid #dddee6;
            color: #787c88;
            text-align: center;
        }

        .shuju:nth-child(odd) {
            background: #ffffff
        }

        .shuju:nth-child(even) {
            background: #f3f5fb
        }

        .shuju:last-child {
            border-bottom: 1px solid #dddee6;
        }

        .shuju:HOVER {
            background: #fff6cd;
        }

        ul {
            border: none;
        }

        .seachform li label {
            line-height: 45px;
            color: #444444
        }

        thead {
            background: #f2f2f2
        }

        tbody tr:nth-child(even) {
            background: #f7f8fd
        }

        .tablelist th {
            height: 45px;
            text-align: center;
            background: none;
            border-bottom: none;
        }

        .tablelist td {
            border-right: none;
            text-align: center;
        }

        tbody tr {
            height: 38px
        }

        a {
            cursor: pointer;
        }

        .placeul a {
            color: #444444
        }

        .success td {
            border: 1px solid #111
        }

        .seachform {
            display: block;
            list-style-type: disc;
            -webkit-margin-before: 1em;
            -webkit-margin-after: 1em;
            -webkit-margin-start: 0px;
            -webkit-margin-end: 0px;
            -webkit-padding-start: 40px;
        }

        .seachform {
            display: block;
            margin: 0;
            padding: 0;
            list-style: none;
            border-bottom: none
        }

        .rightinfo {
            padding: 8px;
            font-size: 12px
        }

        .scbtn {
            background: #57a0ff;
            border-radius: 20px;
            width: 110px;
            height: 35px;
            margin-left: 40px;
            font-size: 14px;
            font-weight: bold;
            color: #fff;
            cursor: pointer;
            outline: none;
            border: none;
        }

        a, a:focus {
            text-decoration: none;
            color: #000;
            outline: none;
            blr: expression(this.onFocus=this.blur());
        }

        .seachform li {
            float: left;
            margin-right: 15px;
        }

        li {
            display: block;
            margin: 0;
            padding: 0;
            list-style: none;
        }

        .placeul li:last-child {
            background: none;
        }

        .seachform li label {
            margin-right: 10px
        }

        .placeul li {
            float: left;
            line-height: 40px;
            padding-left: 7px;
            padding-right: 12px;

            font-size: 9px
        }

        ul {
            border-bottom: none;
        }
        .template tr td:nth-child(0){
        	background-color: white;
        }
    </style>
</head>
<body style="background: #f5f5f5;padding: 0 10px;">
<div class="place" style="background: #f5f5f5; margin-top: 10px">
    <ul class="placeul">
        <li><a href="#">报表</a></li>
        <li><a href="#">管理报表</a></li>
        <li><a href="<%=path%>/DrivingSys/queryRecruitStudentDeductCollectJournal/look.action">招生提成汇总表</a></li>
    </ul>
</div>

<div class="rightinfo"
     style="background: #fff; border-radius: 10px; height: 45px;">

     <form action="<%=path%>/DrivingSys/queryRecruitStudentDeductCollectJournal/look.action" method="post">
        <ul class="seachform" >      	
            <%-- <li><label>开始时间</label><input class="scinput1" name="beginTime"
                                          type="text"
                                          onfocus="WdatePicker({maxDate:'#F{$dp.$D(\'datemax\')||\'%y-%M-%d\'}',dateFmt:'yyyy-MM-dd'})"
                                          id="datemin" class="input-text Wdate" style="width: 150px;"
                                          value="${beginTime}"></li>
            <li><label>结束时间</label><input class="scinput1" name="endTime"
                                          type="text"
                                          onfocus="WdatePicker({minDate:'#F{$dp.$D(\'datemin\')}',maxDate:'%y-%M-%d',dateFmt:'yyyy-MM-dd'})"
                                          id="datemax" class="input-text Wdate" style="width: 150px;"
                                          value="${endTime}"></li>
            <li><label>人员</label><input class="scinput1" name="person"
                                        type="text" class="input-text Wdate" style="width: 150px;"
                                        value="${person }" id="person"></li>            
            <li><label>&nbsp;</label><input name="" type="submit"
                                            class="scbtn" value="立即查询"/></li> --%>
                <shiro:hasPermission name="/outXlsRecruitStudentDeductCollect">
                    <li><label>&nbsp;</label><input name="" type="button" id="dc"
                                                    class="scbtn" value="导出Excel" /></li>
                </shiro:hasPermission>
        </ul>
    </form>
</div>
<form action="<%=path%>/DrivingSys/outXls" method="post" id="outXls">
    <input id="xls" type="hidden" name="xls" value="">
    <input type="hidden" name="fileNames" value="${time}招生提成汇总表">
</form>

<div style="width: 100%; overflow: auto; margin-top: 30px; background: #fff; box-shadow: 0 0 10px #f2f2f2; min-height: 600px;"
     class="info">
    <table class="template tablelist" style="width: 70%; border-spacing: 0px" align="center">  	
     	<tr class="tou">
     		<th colspan="7" style="text-align: center; width: 10px;font-size: 18px;">招生提成汇总表</th>
     	</tr>
     	<tr class="tou">           
            <th style="text-align: center; width: 10px">序号</th>
            <th style="text-align: center; width: 10px">项目</th> 
            <th style="text-align: center; width: 10px">部门</th>
            <th style="text-align: center; width: 10px">数量</th>  
            <th style="text-align: center; width: 10px" >招生提成</th>
            <th style="text-align: center; width: 10px">预留金额</th>
            <th style="text-align: center; width: 10px">小计</th>      
        </tr>      
        <tr class="shuju">
            <td rowspan="3" style="text-align: center; width: 15px;background: #ffffff;">1</td>
            <td rowspan="3"  style="text-align: center; width: 15px;background: #ffffff;">大车</td>
            <td style="text-align: center; width: 10px">招生部门</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>
        <tr class="shuju">           
            <td style="text-align: center; width: 10px">非招生部门</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>  
        <tr class="shuju">           
            <td style="text-align: center; width: 10px">小计</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>
        <tr class="shuju">
            <td rowspan="4" style="text-align: center; width: 15px;background: #ffffff;">2</td>
            <td rowspan="4"  style="text-align: center; width: 15px;background: #ffffff;">小车</td>
            <td style="text-align: center; width: 10px">招生部门</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>
        <tr class="shuju">           
            <td style="text-align: center; width: 10px">非招生部门</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>
         <tr class="shuju">           
            <td style="text-align: center; width: 10px">自来</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>    
        <tr class="shuju">           
            <td style="text-align: center; width: 10px">小计</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>
        <tr class="shuju">
            <td rowspan="4" style="text-align: center; width: 15px;background: #ffffff;">3</td>
            <td rowspan="4"  style="text-align: center; width: 15px;background: #ffffff;">学生</td>
            <td style="text-align: center; width: 10px">招生部门</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>
        <tr class="shuju">           
            <td style="text-align: center; width: 10px">非招生部门</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>
         <tr class="shuju">           
            <td style="text-align: center; width: 10px">自来</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>    
        <tr class="shuju">           
            <td style="text-align: center; width: 10px">小计</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>
        <tr class="shuju">
            <td rowspan="3" style="text-align: center; width: 15px;background: #ffffff;">4</td>
            <td rowspan="3"  style="text-align: center; width: 15px;background: #ffffff;">话费、交通及超额补贴</td>
            <td style="text-align: center; width: 10px">招生部门</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>
        <tr class="shuju">           
            <td style="text-align: center; width: 10px">非招生部门</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>           
        <tr class="shuju">           
            <td style="text-align: center; width: 10px">小计</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>
          <tr class="shuju">
            <td rowspan="4" style="text-align: center; width: 15px;background: #ffffff;">5</td>
            <td rowspan="4"  style="text-align: center; width: 15px;background: #ffffff;">罚款</td>
            <td style="text-align: center; width: 10px">招生部门</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>
        <tr class="shuju">           
            <td style="text-align: center; width: 10px">非招生部门</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>
         <tr class="shuju">           
            <td style="text-align: center; width: 10px">自来</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>    
        <tr class="shuju">           
            <td style="text-align: center; width: 10px">小计</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>
        <tr class="shuju">
           <!--  <td rowspan="3" style="text-align: center; width: 15px"></td> -->
            <td rowspan="3" colspan="2" style="text-align: center; width: 15px;background: #ffffff;">汇总</td>
            <td style="text-align: center; width: 10px">招生部门</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>
        <tr class="shuju">           
            <td style="text-align: center; width: 10px">非招生部门</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>           
        <tr class="shuju">           
            <td style="text-align: center; width: 10px">合计</td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>
            <td style="text-align: center; width: 10px"></td>           
        </tr>                                      
    </table>
</div>
</body>
<script type="text/javascript" src="<%=path%>/JQuery/jquery-1.8.2.js"></script>
<%@ include file="/WEB-INF/JSP/ajax.jsp" %>
<script type="text/javascript">
    $(document).ready(function () {
    	//处理序号
    	$(".xuhao").each(function(i){
    		$(this).text(i+1);
    	})
    })

    $("#dc").click(function () {        
        var tableHtml = $(".info").html()
        $("#xls").val(tableHtml)       
        $("#outXls").submit();

    })
  
    //num是要处理的数字  v为要保留的小数位数
	function decimal(num,v){
		var vv = Math.pow(10,v);
	return Math.round(num*vv)/vv;
	}
</script>
</html>